SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `qm_site_menu`
-- ----------------------------
DROP TABLE IF EXISTS `qm_site_menu`;
CREATE TABLE `qm_site_menu` (
  `menu_id` mediumint(6) NOT NULL AUTO_INCREMENT,
  `parent_id` mediumint(6) NOT NULL DEFAULT '0' COMMENT '父菜单id',
  `name` varchar(20) NOT NULL COMMENT '名称',
  `url` varchar(255) DEFAULT NULL COMMENT '路径',
  `description` varchar(150) DEFAULT NULL COMMENT '描述',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态 0 启用  ，1禁用，默认0',
  `display_order` int(10) NOT NULL DEFAULT '0' COMMENT 'display_order',
  `permission_id` int(10) NOT NULL COMMENT '权限编号',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `icon` varchar(100) DEFAULT NULL COMMENT '图标',
  `deleted_at` datetime DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`menu_id`),
  KEY `menu_permission_status` (`permission_id`,`display_order`,`status`),
  KEY `menu_pid_stime` (`parent_id`,`display_order`,`updated_at`)
) ENGINE=InnoDB AUTO_INCREMENT=99 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `qm_site_menu`
-- ----------------------------
BEGIN;
INSERT INTO `qm_site_menu` VALUES ('1', '0', '我的面板', '/admin/index', 'index', '0', '0', '1', '2015-11-18 19:50:28', '2015-11-20 14:08:29', null, null), ('2', '1', '服务器状态', '', 'index1', '0', '0', '0', '2015-11-18 19:50:28', '2015-11-18 19:50:28', null, null), ('3', '2', '服务器信息', '/admin/index/server', 'index1_1', '0', '0', '2', '2015-11-18 19:50:28', '2015-11-20 13:55:37', null, null), ('4', '1', '个人信息', '', 'index2', '0', '0', '0', '2015-11-18 19:50:28', '2015-11-18 19:50:28', null, null), ('5', '4', '个人信息', '/admin/index/owner', 'index2_1', '0', '0', '3', '2015-11-18 19:50:28', '2015-11-20 13:56:02', null, null), ('6', '4', '密码修改', '/admin/index/modifypwd', 'index2_2', '0', '0', '3', '2015-11-18 19:50:28', '2015-11-20 13:56:25', null, null), ('7', '0', '就业指南', '/admin/employ', 'employ', '0', '0', '5', '2015-11-18 19:50:28', '2015-11-20 14:09:57', null, null), ('8', '7', '就业指南', '', 'employ1', '0', '0', '0', '2015-11-18 19:50:28', '2015-11-18 19:50:28', '', null), ('9', '8', '未审核', '/admin/employ/noverify', 'employ1_1', '0', '0', '6', '2015-11-18 19:50:28', '2015-11-20 14:00:16', null, null), ('10', '8', '就业指南', '/admin/employ/index', 'employ1_2', '0', '0', '6', '2015-11-18 19:50:28', '2015-11-20 14:00:30', null, null), ('11', '8', '分类管理', '/admin/employ/category', 'employ1_3', '0', '0', '9', '2015-11-18 19:50:28', '2015-11-20 14:00:43', null, null), ('12', '7', '评论管理', '', 'employ2', '0', '0', '0', '2015-11-18 19:50:28', '2015-11-18 19:50:28', null, null), ('13', '12', '就业指南评论', '/admin/employ/comment', 'employ2_1', '0', '0', '12', '2015-11-18 19:50:28', '2015-11-20 14:01:39', '', null), ('14', '0', '充电加油', '/admin/teaches', 'teaches', '0', '0', '15', '2015-11-18 19:50:28', '2015-11-20 14:09:45', null, null), ('15', '14', '职场技能', '', 'teaches1', '0', '0', '0', '2015-11-18 19:50:28', '2015-11-18 19:50:28', '', null), ('16', '15', '未审核', '/admin/teaches/noverify', 'teaches1_1', '0', '0', '16', '2015-11-18 19:50:28', '2015-11-20 14:03:07', null, null), ('17', '15', '职场技能', '/admin/teaches/index', 'teaches1_2', '0', '0', '16', '2015-11-18 19:50:28', '2015-11-20 14:03:25', '', null), ('18', '15', '分类管理', '/admin/teaches/category', 'teaches1_3', '0', '0', '16', '2015-11-18 19:50:28', '2015-11-20 14:04:15', '', null), ('19', '14', '企业专区', '', 'teaches2', '0', '0', '0', '2015-11-18 19:50:28', '2015-11-18 19:50:28', '', null), ('20', '19', '未审核', '/admin/teaches/compverify', 'teaches2_1', '0', '0', '19', '2015-11-18 19:50:28', '2015-11-20 14:04:56', null, null), ('21', '19', '企业专区', '/admin/teaches/enterprise', 'teaches2_2', '0', '0', '19', '2015-11-18 19:50:28', '2015-11-20 14:05:11', null, null), ('22', '19', '企业管理', '/admin/teaches/company', 'teaches2_3', '0', '0', '19', '2015-11-18 19:50:28', '2015-11-20 14:05:26', null, null), ('23', '14', '推荐机构', '', 'teaches3', '0', '0', '0', '2015-11-18 19:50:28', '2015-11-18 19:50:28', '', null), ('24', '23', '机构种类', '/admin/teaches/organization/category', 'teaches3_1', '0', '0', '22', '2015-11-18 19:50:28', '2015-11-20 14:05:50', '', null), ('25', '23', '机构管理', '/admin/teaches/organization/index', 'teaches3_2', '0', '0', '22', '2015-11-18 19:50:28', '2015-11-20 14:06:12', '', null), ('26', '23', '课程管理', '/admin/teaches/organization/class', 'teaches3_3', '0', '0', '25', '2015-11-18 19:50:28', '2015-11-20 14:06:28', '', null), ('27', '14', '评论管理', '', 'teaches4', '0', '0', '0', '2015-11-18 19:50:28', '2015-11-18 19:50:28', '', null), ('28', '27', '充电加油评论', '/admin/teaches/comment', 'teaches4_1', '0', '0', '28', '2015-11-18 19:50:28', '2015-11-20 14:07:02', null, null), ('29', '27', '机构课程评论', '/admin/teaches/class/comment', 'teaches4_2', '0', '0', '28', '2015-11-18 19:50:28', '2015-11-20 14:07:22', '', null), ('30', '0', '企业招聘', '/admin/enterprise', 'enterprise', '0', '0', '31', '2015-11-18 19:50:28', '2015-11-20 14:09:07', null, null), ('31', '30', '企业管理', '', 'enterprise1', '0', '0', '0', '2015-11-18 19:50:28', '2015-11-18 19:50:28', '', null), ('32', '31', '未审核', '/admin/enterprise/noverify', 'enterprise1_1', '0', '0', '32', '2015-11-18 19:50:28', '2015-11-20 14:10:55', '', null), ('33', '31', '企业管理', '/admin/enterprise/companys', 'enterprise1_2', '0', '0', '32', '2015-11-18 19:50:28', '2015-11-20 14:11:11', '', null), ('34', '31', '企业用户', '/admin/enterprise/users', 'enterprise1_3', '0', '0', '35', '2015-11-18 19:50:28', '2015-11-20 14:11:29', null, null), ('35', '31', '行业分类', '/admin/enterprise/company_type', 'enterprise1_4', '0', '0', '38', '2015-11-18 19:50:28', '2015-11-20 14:11:49', '', null), ('36', '31', '图片库', '/admin/enterprise/pictures', 'enterprise1_5', '0', '0', '41', '2015-11-18 19:50:28', '2015-11-20 14:12:10', null, null), ('37', '31', '企业规模', '/admin/enterprise/company_scale', 'enterprise1_6', '0', '0', '44', '2015-11-18 19:50:28', '2015-11-20 14:12:28', '', null), ('38', '31', '企业发展阶段', '/admin/enterprise/company_develop', 'enterprise1_7', '0', '0', '47', '2015-11-18 19:50:28', '2015-11-20 14:12:45', '', null), ('39', '30', '职位管理', '', 'enterprise2', '0', '0', '0', '2015-11-18 19:50:28', '2015-11-18 19:50:28', '', null), ('43', '39', '未审核', '/admin/enterprise/jobs/noverify', 'enterprise2_1', '0', '0', '50', '2015-11-18 19:50:28', '2015-11-20 14:15:39', '', null), ('44', '39', '职位管理', '/admin/enterprise/jobs/index', 'enterprise2_2', '0', '0', '50', '2015-11-18 19:50:28', '2015-11-20 14:15:55', '', null), ('45', '39', '职位分类', '/admin/enterprise/job_type', 'enterprise2_3', '0', '0', '53', '2015-11-18 19:50:28', '2015-11-20 14:16:12', null, null), ('46', '30', '投递管理', '', 'enterprise3', '0', '0', '0', '2015-11-18 19:50:28', '2015-11-18 19:50:28', '', null), ('47', '46', '简历投递箱', '/admin/enterprise/folder', 'enterprise3_1', '0', '0', '56', '2015-11-18 19:50:28', '2015-11-20 14:16:42', '', null), ('48', '46', '企业人才库', '/admin/enterprise/inbox', 'enterprise3_2', '0', '0', '56', '2015-11-18 19:50:28', '2015-11-20 14:16:58', '', null), ('49', '30', '评论管理', '', 'enterprise4', '0', '0', '0', '2015-11-18 19:50:28', '2015-11-18 19:50:28', '', null), ('50', '49', '评论管理', '/admin/enterprise/comments', 'enterprise4_1', '0', '0', '59', '2015-11-18 19:50:28', '2015-11-20 14:17:38', '', null), ('51', '30', '认证管理', '', 'enterprise5', '0', '0', '0', '2015-11-18 19:50:28', '2015-11-18 19:50:28', '', null), ('52', '51', '系统认证类别', '/admin/enterprise/auth_type', 'enterprise5_1', '0', '0', '62', '2015-11-18 19:50:28', '2015-11-20 14:18:07', '', null), ('53', '51', '企业认证', '/admin/enterprise/company_auth', 'enterprise5_2', '0', '0', '62', '2015-11-18 19:50:28', '2015-11-20 14:18:22', '', null), ('54', '30', '试卷管理', '', 'enterprise6', '0', '0', '0', '2015-11-18 19:50:28', '2015-11-18 19:50:28', '', null), ('55', '54', '题库管理', '/admin/enterprise/questions', 'enterprise6_1', '0', '0', '65', '2015-11-18 19:50:28', '2015-11-20 14:18:40', '', null), ('56', '54', '试卷管理', '/admin/enterprise/examinations', 'enterprise6_2', '0', '0', '65', '2015-11-18 19:50:28', '2015-11-20 14:19:02', '', null), ('57', '54', '考试纪录', '/admin/enterprise/test_record', 'enterprise6_3', '0', '0', '65', '2015-11-18 19:50:28', '2015-11-20 14:19:41', '', null), ('58', '0', '青苜社区', '/admin/bbs', 'bbs', '0', '0', '68', '2015-11-18 19:50:28', '2015-11-20 14:19:57', null, null), ('59', '58', '基本设置', '', 'bbs1', '0', '0', '0', '2015-11-18 19:50:28', '2015-11-18 19:50:28', '', null), ('60', '59', '板块设置', '/admin/bbs/category', 'bbs1_1', '0', '0', '69', '2015-11-18 19:50:28', '2015-11-20 14:21:02', '', null), ('61', '59', '内容设置', '/admin/bbs/content', 'bbs1_2', '0', '0', '72', '2015-11-18 19:50:28', '2015-11-20 14:21:22', '', null), ('62', '59', '防灌水设置', '/admin/bbs/permission', 'bbs1_3', '0', '0', '74', '2015-11-18 19:50:28', '2015-11-20 14:21:39', '', null), ('63', '58', '内容管理', '', 'bbs2', '0', '0', '0', '2015-11-18 19:50:28', '2015-11-18 19:50:28', '', null), ('64', '63', '帖子管理', '/admin/bbs/questions/index', 'bbs2_1', '0', '0', '76', '2015-11-18 19:50:28', '2015-11-20 14:22:10', '', null), ('65', '63', '回复管理', '/admin/bbs/answers/index', 'bbs2_2', '0', '0', '79', '2015-11-18 19:50:28', '2015-11-20 14:22:28', '', null), ('66', '63', '评论管理', '/admin/bbs/comments/index', 'bbs2_3', '0', '0', '82', '2015-11-18 19:50:28', '2015-11-20 14:22:43', '', null), ('67', '0', '内容管理', '/admin/content', 'content', '0', '0', '85', '2015-11-18 19:50:28', '2015-11-20 14:23:14', '', null), ('68', '67', '基本设置', '', 'content1', '0', '0', '0', '2015-11-18 19:50:28', '2015-11-18 19:50:28', '', null), ('69', '68', '基本信息', '/admin/content/info', 'content1_1', '0', '0', '86', '2015-11-18 19:50:28', '2015-11-20 14:23:38', null, null), ('70', '68', '首页轮播', '/admin/content/banner', 'content1_2', '0', '0', '88', '2015-11-18 19:50:28', '2015-11-20 14:24:02', null, null), ('71', '68', '模块介绍', '/admin/content/module', 'content1_3', '0', '0', '91', '2015-11-18 19:50:28', '2015-11-20 14:24:20', null, null), ('72', '68', '热门推荐', '/admin/content/morehot', 'content1_4', '0', '0', '94', '2015-11-18 19:50:28', '2015-11-20 14:24:39', null, null), ('73', '68', '友情链接', '/admin/content/link', 'content1_5', '0', '0', '97', '2015-11-18 19:50:28', '2015-11-20 14:24:56', null, null), ('74', '67', '广告管理', '', 'content2', '0', '0', '0', '2015-11-18 19:50:28', '2015-11-18 19:50:28', '', null), ('75', '74', '投放位管理', '/admin/content/position', 'content2_1', '0', '0', '106', '2015-11-18 19:50:28', '2015-11-20 14:25:37', '', null), ('76', '74', '广告管理', '/admin/content/ads', 'content2_2', '0', '0', '103', '2015-11-18 19:50:28', '2015-11-20 14:25:52', '', null), ('77', '0', '用户管理', '/admin/users', 'users', '0', '0', '109', '2015-11-18 19:50:28', '2015-11-20 14:26:09', null, null), ('78', '77', '用户管理', '', 'users1', '0', '0', '0', '2015-11-18 19:50:28', '2015-11-18 19:50:28', '', null), ('79', '78', '用户管理', '/admin/users/users', 'users1_1', '0', '0', '110', '2015-11-18 19:50:28', '2015-11-20 14:26:32', '', null), ('80', '77', '交易管理', '', 'users2', '0', '0', '0', '2015-11-18 19:50:28', '2015-11-18 19:50:28', null, null), ('81', '80', '充值记录', '/admin/users/charge', 'users2_1', '0', '0', '113', '2015-11-18 19:50:28', '2015-11-20 14:26:48', null, null), ('82', '80', '积分消费', '/admin/users/consume', 'users2_2', '0', '0', '116', '2015-11-18 19:50:28', '2015-11-20 14:27:03', null, null), ('83', '77', '简历管理', '', 'users3', '0', '0', '0', '2015-11-18 19:50:28', '2015-11-18 19:50:28', '', null), ('84', '83', '用户简历', '/admin/users/resume', 'users3_1', '0', '0', '122', '2015-11-18 19:50:28', '2015-11-20 14:27:37', null, null), ('85', '83', '简历状态', '/admin/users/restatus', 'users3_2', '0', '0', '125', '2015-11-18 19:50:28', '2015-11-20 14:27:54', null, null), ('86', '77', '会员管理', '', 'users4', '0', '0', '0', '2015-11-18 19:50:28', '2015-11-18 19:50:28', '', null), ('87', '86', '会员组管理', '/admin/users/group', 'users4_1', '0', '0', '128', '2015-11-18 19:50:28', '2015-11-20 14:28:11', null, null), ('88', '86', '权限管理', '/admin/users/permission', 'users4_2', '0', '0', '131', '2015-11-18 19:50:28', '2015-11-20 14:28:30', null, null), ('89', '77', '消息管理', '', 'users5', '0', '0', '0', '2015-11-18 19:50:28', '2015-11-18 19:50:28', '', null), ('90', '89', '用户私信管理', '/admin/users/message', 'users5_1', '0', '0', '134', '2015-11-18 19:50:28', '2015-11-20 14:28:44', null, null), ('91', '89', '举报管理', '/admin/users/report', 'users5_2', '0', '0', '137', '2015-11-18 19:50:28', '2015-11-20 14:29:00', null, null), ('92', '80', '积分新增', '/admin/users/points', 'users5_3', '0', '0', '119', '2015-11-18 19:50:28', '2015-11-20 14:27:20', null, null), ('93', '0', '系统设置', '/admin/setting', 'setting', '0', '0', '140', '2015-11-18 19:50:28', '2015-11-20 14:29:14', null, null), ('94', '93', '权限管理', '', 'setting1', '0', '0', '0', '2015-11-18 19:50:28', '2015-11-18 19:50:28', '', null), ('95', '94', '管理员', '/admin/setting/admin', 'setting1_1', '0', '0', '141', '2015-11-18 19:50:28', '2015-11-20 14:29:27', '', null), ('96', '94', '角色管理', '/admin/setting/roles', 'setting1_2', '0', '0', '144', '2015-11-18 19:50:28', '2015-11-20 14:29:41', '', null), ('97', '94', '后台菜单', '/admin/setting/menu', 'setting1_3', '0', '0', '147', '2015-11-18 19:50:28', '2015-11-20 14:29:56', '', null), ('98', '68', '地区管理', '/admin/content/area', 'content1_6', '0', '0', '100', '2015-11-19 13:15:11', '2015-11-20 14:25:13', null, null);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;

